Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 66450 |
| Missing cells | 142192 |
| Missing cells (%) | 9.7% |
| Duplicate rows | 1413 |
| Duplicate rows (%) | 2.1% |
| Total size in memory | 10.5 MiB |
| Average record size in memory | 165.0 B |
Variable types
| Text | 4 |
|---|---|
| DateTime | 5 |
| Numeric | 7 |
| Categorical | 3 |
| Boolean | 2 |
| Unsupported | 1 |
timezone has constant value "America/Los_Angeles" | Constant |
paymentRequired has constant value "True" | Constant |
| Dataset has 1413 (2.1%) duplicate rows | Duplicates |
connectionWeekdayName is highly overall correlated with isWeekend | High correlation |
isWeekend is highly overall correlated with connectionWeekdayName | High correlation |
kWhDelivered is highly overall correlated with kWhRequested and 1 other fields | High correlation |
kWhRequested is highly overall correlated with kWhDelivered and 1 other fields | High correlation |
milesRequested is highly overall correlated with kWhDelivered and 1 other fields | High correlation |
isWeekend is highly imbalanced (57.7%) | Imbalance |
doneChargingTime has 4088 (6.2%) missing values | Missing |
userID has 17263 (26.0%) missing values | Missing |
WhPerMile has 17263 (26.0%) missing values | Missing |
kWhRequested has 17263 (26.0%) missing values | Missing |
milesRequested has 17263 (26.0%) missing values | Missing |
minutesAvailable has 17263 (26.0%) missing values | Missing |
modifiedAt has 17263 (26.0%) missing values | Missing |
paymentRequired has 17263 (26.0%) missing values | Missing |
requestedDeparture has 17263 (26.0%) missing values | Missing |
connectionTimespan is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-11-14 18:43:02.280811 |
|---|---|
| Analysis finished | 2024-11-14 18:43:06.638762 |
| Duration | 4.36 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
id
Text
| Distinct | 65037 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Unique
| Unique | 63624 ? |
|---|---|
| Unique (%) | 95.7% |
Sample
| 1st row | 5e23b149f9af8b5fe4b973cf |
|---|---|
| 2nd row | 5e23b149f9af8b5fe4b973d0 |
| 3rd row | 5e23b149f9af8b5fe4b973d1 |
| 4th row | 5e23b149f9af8b5fe4b973d2 |
| 5th row | 5e23b149f9af8b5fe4b973d3 |
| Value | Count | Frequency (%) |
| 5d3b9b4ff9af8b7392318319 | 2 | < 0.1% |
| 5d4f61d6f9af8b30fe7ecfe8 | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c0364a | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c03649 | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c03648 | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c03647 | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c03646 | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c03645 | 2 | < 0.1% |
| 5d574ad2f9af8b4c10c0364d | 2 | < 0.1% |
| 5d55f950f9af8b45dfb3d8a3 | 2 | < 0.1% |
| Other values (65027) | 66430 |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 186880 | |
| b | 134254 | 8.4% |
| 9 | 132068 | 8.3% |
| a | 125894 | 7.9% |
| 8 | 123025 | 7.7% |
| 5 | 116280 | 7.3% |
| c | 92936 | 5.8% |
| d | 89241 | 5.6% |
| 6 | 88316 | 5.5% |
| 7 | 79006 | 5.0% |
| Other values (6) | 426900 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1594800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| f | 186880 | |
| b | 134254 | 8.4% |
| 9 | 132068 | 8.3% |
| a | 125894 | 7.9% |
| 8 | 123025 | 7.7% |
| 5 | 116280 | 7.3% |
| c | 92936 | 5.8% |
| d | 89241 | 5.6% |
| 6 | 88316 | 5.5% |
| 7 | 79006 | 5.0% |
| Other values (6) | 426900 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1594800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| f | 186880 | |
| b | 134254 | 8.4% |
| 9 | 132068 | 8.3% |
| a | 125894 | 7.9% |
| 8 | 123025 | 7.7% |
| 5 | 116280 | 7.3% |
| c | 92936 | 5.8% |
| d | 89241 | 5.6% |
| 6 | 88316 | 5.5% |
| 7 | 79006 | 5.0% |
| Other values (6) | 426900 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1594800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| f | 186880 | |
| b | 134254 | 8.4% |
| 9 | 132068 | 8.3% |
| a | 125894 | 7.9% |
| 8 | 123025 | 7.7% |
| 5 | 116280 | 7.3% |
| c | 92936 | 5.8% |
| d | 89241 | 5.6% |
| 6 | 88316 | 5.5% |
| 7 | 79006 | 5.0% |
| Other values (6) | 426900 |
connectionTime
Date
| Distinct | 64839 |
|---|---|
| Distinct (%) | 97.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
| Minimum | 2018-04-25 04:08:04-07:00 |
|---|---|
| Maximum | 2021-09-13 22:43:39-07:00 |
disconnectTime
Date
| Distinct | 64906 |
|---|---|
| Distinct (%) | 97.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
| Minimum | 2018-04-25 06:20:10-07:00 |
|---|---|
| Maximum | 2021-09-14 07:46:28-07:00 |
doneChargingTime
Date
Missing 
| Distinct | 60637 |
|---|---|
| Distinct (%) | 97.2% |
| Missing | 4088 |
| Missing (%) | 6.2% |
| Memory size | 519.3 KiB |
| Minimum | 2018-04-25 06:21:10-07:00 |
|---|---|
| Maximum | 2021-09-14 07:46:22-07:00 |
kWhDelivered
Real number (ℝ)
High correlation 
| Distinct | 25629 |
|---|---|
| Distinct (%) | 38.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.787916 |
| Minimum | 0.501 |
|---|---|
| Maximum | 108.79724 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 519.3 KiB |
Quantile statistics
| Minimum | 0.501 |
|---|---|
| 5-th percentile | 0.917 |
| Q1 | 5.097 |
| median | 9.14 |
| Q3 | 14.183 |
| 95-th percentile | 34.8814 |
| Maximum | 108.79724 |
| Range | 108.29624 |
| Interquartile range (IQR) | 9.086 |
Descriptive statistics
| Standard deviation | 10.314789 |
|---|---|
| Coefficient of variation (CV) | 0.87503069 |
| Kurtosis | 3.9074214 |
| Mean | 11.787916 |
| Median Absolute Deviation (MAD) | 4.657 |
| Skewness | 1.8274044 |
| Sum | 783307.05 |
| Variance | 106.39486 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.886 | 31 | < 0.1% |
| 0.901 | 31 | < 0.1% |
| 0.878 | 30 | < 0.1% |
| 0.86 | 28 | < 0.1% |
| 0.897 | 28 | < 0.1% |
| 0.852 | 27 | < 0.1% |
| 13.893 | 27 | < 0.1% |
| 13.874 | 26 | < 0.1% |
| 0.853 | 26 | < 0.1% |
| 0.892 | 26 | < 0.1% |
| Other values (25619) | 66170 |
| Value | Count | Frequency (%) |
| 0.501 | 3 | |
| 0.502 | 5 | |
| 0.503 | 2 | < 0.1% |
| 0.5037679211 | 1 | < 0.1% |
| 0.505 | 1 | < 0.1% |
| 0.506 | 2 | < 0.1% |
| 0.507 | 2 | < 0.1% |
| 0.508 | 2 | < 0.1% |
| 0.5081750299 | 1 | < 0.1% |
| 0.509 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 108.7972417 | 1 | |
| 89.36273194 | 1 | |
| 77.7 | 1 | |
| 75.696 | 1 | |
| 75.528 | 1 | |
| 72.582 | 1 | |
| 69.74 | 1 | |
| 69.373 | 1 | |
| 68.74 | 1 | |
| 68.609 | 1 |
sessionID
Text
| Distinct | 65037 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
Length
| Max length | 39 |
|---|---|
| Median length | 38 |
| Mean length | 37.991543 |
| Min length | 37 |
Unique
| Unique | 63624 ? |
|---|---|
| Unique (%) | 95.7% |
Sample
| 1st row | 1_1_179_810_2020-01-02 13:08:53.870034 |
|---|---|
| 2nd row | 1_1_193_825_2020-01-02 13:36:49.599853 |
| 3rd row | 1_1_193_829_2020-01-02 13:56:35.214993 |
| 4th row | 1_1_193_820_2020-01-02 13:59:58.309319 |
| 5th row | 1_1_193_819_2020-01-02 14:00:00.779967 |
| Value | Count | Frequency (%) |
| 2_39_81_4550_2021-07-06 | 9 | < 0.1% |
| 2_39_81_4550_2021-08-21 | 9 | < 0.1% |
| 2_39_81_4550_2021-08-01 | 9 | < 0.1% |
| 2_39_130_31_2018-10-28 | 9 | < 0.1% |
| 2_39_81_4550_2021-08-28 | 9 | < 0.1% |
| 2_39_81_4550_2021-09-10 | 8 | < 0.1% |
| 2_39_81_4550_2021-06-24 | 8 | < 0.1% |
| 2_39_81_4550_2021-06-19 | 8 | < 0.1% |
| 2_39_127_19_2018-07-28 | 8 | < 0.1% |
| 2_39_81_4550_2021-07-04 | 8 | < 0.1% |
| Other values (111178) | 132815 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 389675 | |
| 2 | 278190 | |
| _ | 265800 | |
| 0 | 262018 | |
| 9 | 188446 | |
| 3 | 165220 | 6.5% |
| 8 | 145176 | 5.8% |
| - | 132900 | 5.3% |
| : | 132900 | 5.3% |
| 7 | 124082 | 4.9% |
| Other values (5) | 440131 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2524538 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 389675 | |
| 2 | 278190 | |
| _ | 265800 | |
| 0 | 262018 | |
| 9 | 188446 | |
| 3 | 165220 | 6.5% |
| 8 | 145176 | 5.8% |
| - | 132900 | 5.3% |
| : | 132900 | 5.3% |
| 7 | 124082 | 4.9% |
| Other values (5) | 440131 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2524538 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 389675 | |
| 2 | 278190 | |
| _ | 265800 | |
| 0 | 262018 | |
| 9 | 188446 | |
| 3 | 165220 | 6.5% |
| 8 | 145176 | 5.8% |
| - | 132900 | 5.3% |
| : | 132900 | 5.3% |
| 7 | 124082 | 4.9% |
| Other values (5) | 440131 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2524538 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 389675 | |
| 2 | 278190 | |
| _ | 265800 | |
| 0 | 262018 | |
| 9 | 188446 | |
| 3 | 165220 | 6.5% |
| 8 | 145176 | 5.8% |
| - | 132900 | 5.3% |
| : | 132900 | 5.3% |
| 7 | 124082 | 4.9% |
| Other values (5) | 440131 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 35042 | |
| 2 | 31408 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 35042 | |
| 2 | 31408 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 35042 | |
| 2 | 31408 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 66450 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 35042 | |
| 2 | 31408 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 66450 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 35042 | |
| 2 | 31408 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 66450 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 35042 | |
| 2 | 31408 |
spaceID
Text
| Distinct | 107 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.5612039 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AG-3F30 |
|---|---|
| 2nd row | AG-1F01 |
| 3rd row | AG-1F03 |
| 4th row | AG-1F04 |
| 5th row | AG-1F06 |
| Value | Count | Frequency (%) |
| ca-303 | 1805 | 2.7% |
| ag-1f08 | 1496 | 2.3% |
| ca-305 | 1411 | 2.1% |
| ag-1f10 | 1313 | 2.0% |
| ag-1f06 | 1251 | 1.9% |
| ag-1f04 | 1192 | 1.8% |
| ag-1f13 | 1170 | 1.8% |
| ca-307 | 1140 | 1.7% |
| 11900388 | 1125 | 1.7% |
| ag-1f02 | 1111 | 1.7% |
| Other values (97) | 53436 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 65325 | |
| - | 65325 | |
| 3 | 46944 | |
| 1 | 41082 | |
| G | 35042 | |
| F | 35042 | |
| C | 30283 | |
| 0 | 27725 | |
| 4 | 26056 | 6.0% |
| 2 | 18603 | 4.3% |
| Other values (5) | 44565 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 435992 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 65325 | |
| - | 65325 | |
| 3 | 46944 | |
| 1 | 41082 | |
| G | 35042 | |
| F | 35042 | |
| C | 30283 | |
| 0 | 27725 | |
| 4 | 26056 | 6.0% |
| 2 | 18603 | 4.3% |
| Other values (5) | 44565 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 435992 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 65325 | |
| - | 65325 | |
| 3 | 46944 | |
| 1 | 41082 | |
| G | 35042 | |
| F | 35042 | |
| C | 30283 | |
| 0 | 27725 | |
| 4 | 26056 | 6.0% |
| 2 | 18603 | 4.3% |
| Other values (5) | 44565 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 435992 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 65325 | |
| - | 65325 | |
| 3 | 46944 | |
| 1 | 41082 | |
| G | 35042 | |
| F | 35042 | |
| C | 30283 | |
| 0 | 27725 | |
| 4 | 26056 | 6.0% |
| 2 | 18603 | 4.3% |
| Other values (5) | 44565 |
stationID
Text
| Distinct | 107 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 10.991543 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1-1-179-810 |
|---|---|
| 2nd row | 1-1-193-825 |
| 3rd row | 1-1-193-829 |
| 4th row | 1-1-193-820 |
| 5th row | 1-1-193-819 |
| Value | Count | Frequency (%) |
| 2-39-139-28 | 1805 | 2.7% |
| 1-1-178-823 | 1496 | 2.3% |
| 2-39-131-30 | 1411 | 2.1% |
| 1-1-178-828 | 1313 | 2.0% |
| 1-1-193-819 | 1251 | 1.9% |
| 1-1-193-820 | 1192 | 1.8% |
| 1-1-194-821 | 1170 | 1.8% |
| 2-39-129-17 | 1140 | 1.7% |
| 2-39-81-4550 | 1125 | 1.7% |
| 1-1-193-827 | 1111 | 1.7% |
| Other values (97) | 53436 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 199350 | |
| 1 | 146746 | |
| 9 | 89636 | |
| 3 | 65730 | 9.0% |
| 2 | 64813 | 8.9% |
| 8 | 55432 | 7.6% |
| 7 | 52951 | 7.2% |
| 4 | 15788 | 2.2% |
| 0 | 15695 | 2.1% |
| 6 | 12755 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 730388 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 199350 | |
| 1 | 146746 | |
| 9 | 89636 | |
| 3 | 65730 | 9.0% |
| 2 | 64813 | 8.9% |
| 8 | 55432 | 7.6% |
| 7 | 52951 | 7.2% |
| 4 | 15788 | 2.2% |
| 0 | 15695 | 2.1% |
| 6 | 12755 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 730388 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 199350 | |
| 1 | 146746 | |
| 9 | 89636 | |
| 3 | 65730 | 9.0% |
| 2 | 64813 | 8.9% |
| 8 | 55432 | 7.6% |
| 7 | 52951 | 7.2% |
| 4 | 15788 | 2.2% |
| 0 | 15695 | 2.1% |
| 6 | 12755 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 730388 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 199350 | |
| 1 | 146746 | |
| 9 | 89636 | |
| 3 | 65730 | 9.0% |
| 2 | 64813 | 8.9% |
| 8 | 55432 | 7.6% |
| 7 | 52951 | 7.2% |
| 4 | 15788 | 2.2% |
| 0 | 15695 | 2.1% |
| 6 | 12755 | 1.7% |
timezone
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
| America/Los_Angeles |
|---|
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | America/Los_Angeles |
|---|---|
| 2nd row | America/Los_Angeles |
| 3rd row | America/Los_Angeles |
| 4th row | America/Los_Angeles |
| 5th row | America/Los_Angeles |
Common Values
| Value | Count | Frequency (%) |
| America/Los_Angeles | 66450 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| america/los_angeles | 66450 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 199350 | |
| A | 132900 | 10.5% |
| s | 132900 | 10.5% |
| m | 66450 | 5.3% |
| r | 66450 | 5.3% |
| i | 66450 | 5.3% |
| c | 66450 | 5.3% |
| a | 66450 | 5.3% |
| / | 66450 | 5.3% |
| L | 66450 | 5.3% |
| Other values (5) | 332250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1262550 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 199350 | |
| A | 132900 | 10.5% |
| s | 132900 | 10.5% |
| m | 66450 | 5.3% |
| r | 66450 | 5.3% |
| i | 66450 | 5.3% |
| c | 66450 | 5.3% |
| a | 66450 | 5.3% |
| / | 66450 | 5.3% |
| L | 66450 | 5.3% |
| Other values (5) | 332250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1262550 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 199350 | |
| A | 132900 | 10.5% |
| s | 132900 | 10.5% |
| m | 66450 | 5.3% |
| r | 66450 | 5.3% |
| i | 66450 | 5.3% |
| c | 66450 | 5.3% |
| a | 66450 | 5.3% |
| / | 66450 | 5.3% |
| L | 66450 | 5.3% |
| Other values (5) | 332250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1262550 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 199350 | |
| A | 132900 | 10.5% |
| s | 132900 | 10.5% |
| m | 66450 | 5.3% |
| r | 66450 | 5.3% |
| i | 66450 | 5.3% |
| c | 66450 | 5.3% |
| a | 66450 | 5.3% |
| / | 66450 | 5.3% |
| L | 66450 | 5.3% |
| Other values (5) | 332250 |
userID
Real number (ℝ)
Missing 
| Distinct | 1006 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1800.4946 |
| Minimum | 1 |
|---|---|
| Maximum | 19923 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 519.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 280.6 |
| Q1 | 431 |
| median | 818 |
| Q3 | 1805 |
| 95-th percentile | 7705 |
| Maximum | 19923 |
| Range | 19922 |
| Interquartile range (IQR) | 1374 |
Descriptive statistics
| Standard deviation | 2617.5486 |
|---|---|
| Coefficient of variation (CV) | 1.4537942 |
| Kurtosis | 11.027097 |
| Mean | 1800.4946 |
| Median Absolute Deviation (MAD) | 439 |
| Skewness | 3.1331269 |
| Sum | 88560927 |
| Variance | 6851560.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 169 | 545 | 0.8% |
| 651 | 510 | 0.8% |
| 405 | 507 | 0.8% |
| 933 | 507 | 0.8% |
| 743 | 485 | 0.7% |
| 562 | 385 | 0.6% |
| 1082 | 382 | 0.6% |
| 3687 | 382 | 0.6% |
| 368 | 353 | 0.5% |
| 420 | 347 | 0.5% |
| Other values (996) | 44784 | |
| (Missing) | 17263 | 26.0% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 22 | 58 | |
| 43 | 1 | < 0.1% |
| 45 | 1 | < 0.1% |
| 58 | 5 | < 0.1% |
| 61 | 43 | |
| 65 | 5 | < 0.1% |
| 66 | 44 | |
| 67 | 61 |
| Value | Count | Frequency (%) |
| 19923 | 1 | < 0.1% |
| 19869 | 1 | < 0.1% |
| 19652 | 1 | < 0.1% |
| 19548 | 3 | |
| 19273 | 3 | |
| 19203 | 1 | < 0.1% |
| 19139 | 4 | |
| 19055 | 2 | |
| 19017 | 1 | < 0.1% |
| 18908 | 1 | < 0.1% |
WhPerMile
Real number (ℝ)
Missing 
| Distinct | 178 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 361.44416 |
| Minimum | 50 |
|---|---|
| Maximum | 2000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 519.3 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 250 |
| Q1 | 288 |
| median | 354 |
| Q3 | 400 |
| 95-th percentile | 600 |
| Maximum | 2000 |
| Range | 1950 |
| Interquartile range (IQR) | 112 |
Descriptive statistics
| Standard deviation | 101.89952 |
|---|---|
| Coefficient of variation (CV) | 0.28192328 |
| Kurtosis | 33.240202 |
| Mean | 361.44416 |
| Median Absolute Deviation (MAD) | 46 |
| Skewness | 2.8196656 |
| Sum | 17778354 |
| Variance | 10383.513 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 400 | 15303 | |
| 250 | 4610 | 6.9% |
| 600 | 3126 | 4.7% |
| 300 | 2575 | 3.9% |
| 333 | 2271 | 3.4% |
| 350 | 1966 | 3.0% |
| 310 | 1169 | 1.8% |
| 200 | 1134 | 1.7% |
| 500 | 1075 | 1.6% |
| 375 | 809 | 1.2% |
| Other values (168) | 15149 | |
| (Missing) | 17263 |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 72 | 3 | < 0.1% |
| 80 | 21 | < 0.1% |
| 120 | 1 | < 0.1% |
| 200 | 1134 | |
| 205 | 2 | < 0.1% |
| 207 | 9 | < 0.1% |
| 208 | 10 | < 0.1% |
| 211 | 7 | < 0.1% |
| 213 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2000 | 22 | < 0.1% |
| 1538 | 10 | < 0.1% |
| 769 | 15 | < 0.1% |
| 630 | 52 | 0.1% |
| 600 | 3126 | |
| 593 | 1 | < 0.1% |
| 590 | 29 | < 0.1% |
| 583 | 9 | < 0.1% |
| 577 | 3 | < 0.1% |
| 575 | 76 | 0.1% |
kWhRequested
Real number (ℝ)
High correlation  Missing 
| Distinct | 1201 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.136324 |
| Minimum | 0 |
|---|---|
| Maximum | 215.32 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 519.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6.66 |
| Q1 | 12 |
| median | 19 |
| Q3 | 32 |
| 95-th percentile | 65.1 |
| Maximum | 215.32 |
| Range | 215.32 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 20.788129 |
|---|---|
| Coefficient of variation (CV) | 0.82701547 |
| Kurtosis | 11.0455 |
| Mean | 25.136324 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 2.5700504 |
| Sum | 1236380.4 |
| Variance | 432.14629 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 3867 | 5.8% |
| 20 | 3186 | 4.8% |
| 12 | 3073 | 4.6% |
| 16 | 2614 | 3.9% |
| 40 | 1536 | 2.3% |
| 24 | 1496 | 2.3% |
| 10 | 1152 | 1.7% |
| 15 | 1136 | 1.7% |
| 30 | 815 | 1.2% |
| 18 | 700 | 1.1% |
| Other values (1191) | 29612 | |
| (Missing) | 17263 |
| Value | Count | Frequency (%) |
| 0 | 17 | |
| 0.256 | 1 | < 0.1% |
| 1.9 | 2 | < 0.1% |
| 2 | 3 | < 0.1% |
| 2.25 | 2 | < 0.1% |
| 2.27 | 2 | < 0.1% |
| 2.5 | 37 | |
| 2.59 | 1 | < 0.1% |
| 2.67 | 2 | < 0.1% |
| 2.73 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 215.32 | 10 | < 0.1% |
| 200 | 22 | < 0.1% |
| 199.95 | 8 | < 0.1% |
| 180 | 30 | |
| 156 | 1 | < 0.1% |
| 153.8 | 11 | < 0.1% |
| 150 | 61 | |
| 149.93 | 2 | < 0.1% |
| 144.76 | 3 | < 0.1% |
| 144 | 1 | < 0.1% |
milesRequested
Real number (ℝ)
High correlation  Missing 
| Distinct | 106 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74.499278 |
| Minimum | 0 |
|---|---|
| Maximum | 775 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 519.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 30 |
| median | 50 |
| Q3 | 100 |
| 95-th percentile | 200 |
| Maximum | 775 |
| Range | 775 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 62.217567 |
|---|---|
| Coefficient of variation (CV) | 0.83514321 |
| Kurtosis | 5.1274858 |
| Mean | 74.499278 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 1.8281768 |
| Sum | 3664396 |
| Variance | 3871.0256 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 8366 | |
| 40 | 6073 | 9.1% |
| 50 | 5790 | 8.7% |
| 30 | 4686 | 7.1% |
| 100 | 4658 | 7.0% |
| 60 | 3147 | 4.7% |
| 80 | 2244 | 3.4% |
| 70 | 1910 | 2.9% |
| 200 | 1358 | 2.0% |
| 90 | 1128 | 1.7% |
| Other values (96) | 9827 | |
| (Missing) | 17263 |
| Value | Count | Frequency (%) |
| 0 | 17 | < 0.1% |
| 1 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 10 | 607 | 0.9% |
| 12 | 1 | < 0.1% |
| 15 | 53 | 0.1% |
| 17 | 9 | < 0.1% |
| 19 | 27 | < 0.1% |
| 20 | 8366 | |
| 21 | 70 | 0.1% |
| Value | Count | Frequency (%) |
| 775 | 8 | < 0.1% |
| 480 | 1 | < 0.1% |
| 422 | 44 | 0.1% |
| 390 | 2 | < 0.1% |
| 330 | 1 | < 0.1% |
| 320 | 79 | 0.1% |
| 310 | 13 | < 0.1% |
| 305 | 3 | < 0.1% |
| 300 | 285 | |
| 290 | 112 | 0.2% |
minutesAvailable
Real number (ℝ)
Missing 
| Distinct | 842 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 358.35959 |
| Minimum | 1 |
|---|---|
| Maximum | 10062 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 519.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 193 |
| median | 360 |
| Q3 | 501 |
| 95-th percentile | 639 |
| Maximum | 10062 |
| Range | 10061 |
| Interquartile range (IQR) | 308 |
Descriptive statistics
| Standard deviation | 196.1254 |
|---|---|
| Coefficient of variation (CV) | 0.5472866 |
| Kurtosis | 122.15961 |
| Mean | 358.35959 |
| Median Absolute Deviation (MAD) | 155 |
| Skewness | 2.8028156 |
| Sum | 17626633 |
| Variance | 38465.173 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 480 | 3041 | 4.6% |
| 60 | 1831 | 2.8% |
| 720 | 773 | 1.2% |
| 120 | 726 | 1.1% |
| 240 | 626 | 0.9% |
| 360 | 616 | 0.9% |
| 300 | 550 | 0.8% |
| 180 | 483 | 0.7% |
| 576 | 346 | 0.5% |
| 288 | 322 | 0.5% |
| Other values (832) | 39873 | |
| (Missing) | 17263 |
| Value | Count | Frequency (%) |
| 1 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 13 | |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 12 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10062 | 1 | < 0.1% |
| 1913 | 1 | < 0.1% |
| 1621 | 1 | < 0.1% |
| 1550 | 1 | < 0.1% |
| 1472 | 1 | < 0.1% |
| 1467 | 13 | |
| 1449 | 1 | < 0.1% |
| 1448 | 8 | < 0.1% |
| 1442 | 32 | |
| 1428 | 8 | < 0.1% |
modifiedAt
Date
Missing 
| Distinct | 47704 |
|---|---|
| Distinct (%) | 97.0% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Memory size | 519.3 KiB |
| Minimum | 2018-04-30 08:08:54-07:00 |
|---|---|
| Maximum | 2021-09-13 22:43:38-07:00 |
paymentRequired
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Memory size | 519.3 KiB |
| True | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 49187 | |
| (Missing) | 17263 | 26.0% |
Missing 
| Distinct | 47773 |
|---|---|
| Distinct (%) | 97.1% |
| Missing | 17263 |
| Missing (%) | 26.0% |
| Memory size | 519.3 KiB |
| Minimum | 2018-04-30 17:17:49-07:00 |
|---|---|
| Maximum | 2021-09-14 10:15:39-07:00 |
connectionTimespan
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
connectionMonth
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.6308352 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 259.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.3182489 |
|---|---|
| Coefficient of variation (CV) | 0.50042698 |
| Kurtosis | -1.0902495 |
| Mean | 6.6308352 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.13455148 |
| Sum | 440619 |
| Variance | 11.010775 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 7362 | |
| 10 | 6582 | |
| 8 | 6457 | |
| 9 | 6123 | |
| 6 | 5769 | |
| 5 | 5658 | |
| 1 | 5339 | |
| 2 | 5218 | |
| 11 | 4925 | |
| 12 | 4508 | |
| Other values (2) | 8509 |
| Value | Count | Frequency (%) |
| 1 | 5339 | |
| 2 | 5218 | |
| 3 | 4484 | |
| 4 | 4025 | |
| 5 | 5658 | |
| 6 | 5769 | |
| 7 | 7362 | |
| 8 | 6457 | |
| 9 | 6123 | |
| 10 | 6582 |
| Value | Count | Frequency (%) |
| 12 | 4508 | |
| 11 | 4925 | |
| 10 | 6582 | |
| 9 | 6123 | |
| 8 | 6457 | |
| 7 | 7362 | |
| 6 | 5769 | |
| 5 | 5658 | |
| 4 | 4025 | |
| 3 | 4484 |
connectionWeekdayName
Categorical
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 519.3 KiB |
| Tuesday | |
|---|---|
| Wednesday | |
| Thursday | |
| Monday | |
| Friday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.2385553 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Thursday |
|---|---|
| 2nd row | Thursday |
| 3rd row | Thursday |
| 4th row | Thursday |
| 5th row | Thursday |
Common Values
| Value | Count | Frequency (%) |
| Tuesday | 12969 | |
| Wednesday | 12767 | |
| Thursday | 12505 | |
| Monday | 12067 | |
| Friday | 10421 | |
| Saturday | 3011 | 4.5% |
| Sunday | 2710 | 4.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| tuesday | 12969 | |
| wednesday | 12767 | |
| thursday | 12505 | |
| monday | 12067 | |
| friday | 10421 | |
| saturday | 3011 | 4.5% |
| sunday | 2710 | 4.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 79217 | |
| a | 69461 | |
| y | 66450 | |
| e | 38503 | |
| s | 38241 | |
| u | 31195 | 6.5% |
| n | 27544 | 5.7% |
| r | 25937 | 5.4% |
| T | 25474 | 5.3% |
| W | 12767 | 2.7% |
| Other values (7) | 66213 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 481002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| d | 79217 | |
| a | 69461 | |
| y | 66450 | |
| e | 38503 | |
| s | 38241 | |
| u | 31195 | 6.5% |
| n | 27544 | 5.7% |
| r | 25937 | 5.4% |
| T | 25474 | 5.3% |
| W | 12767 | 2.7% |
| Other values (7) | 66213 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 481002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| d | 79217 | |
| a | 69461 | |
| y | 66450 | |
| e | 38503 | |
| s | 38241 | |
| u | 31195 | 6.5% |
| n | 27544 | 5.7% |
| r | 25937 | 5.4% |
| T | 25474 | 5.3% |
| W | 12767 | 2.7% |
| Other values (7) | 66213 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 481002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| d | 79217 | |
| a | 69461 | |
| y | 66450 | |
| e | 38503 | |
| s | 38241 | |
| u | 31195 | 6.5% |
| n | 27544 | 5.7% |
| r | 25937 | 5.4% |
| T | 25474 | 5.3% |
| W | 12767 | 2.7% |
| Other values (7) | 66213 |
isWeekend
Boolean
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 65.0 KiB |
| False | |
|---|---|
| True | 5721 |
| Value | Count | Frequency (%) |
| False | 60729 | |
| True | 5721 | 8.6% |
Interactions
Correlations
| WhPerMile | connectionMonth | connectionWeekdayName | isWeekend | kWhDelivered | kWhRequested | milesRequested | minutesAvailable | siteID | userID | |
|---|---|---|---|---|---|---|---|---|---|---|
| WhPerMile | 1.000 | 0.005 | 0.018 | 0.026 | -0.204 | -0.109 | -0.398 | -0.125 | 0.063 | -0.049 |
| connectionMonth | 0.005 | 1.000 | 0.039 | 0.058 | -0.031 | -0.028 | -0.029 | -0.015 | 0.166 | -0.062 |
| connectionWeekdayName | 0.018 | 0.039 | 1.000 | 1.000 | 0.023 | 0.023 | 0.035 | 0.000 | 0.232 | 0.035 |
| isWeekend | 0.026 | 0.058 | 1.000 | 1.000 | 0.014 | 0.044 | 0.071 | 0.005 | 0.226 | 0.080 |
| kWhDelivered | -0.204 | -0.031 | 0.023 | 0.014 | 1.000 | 0.691 | 0.698 | 0.389 | 0.208 | 0.044 |
| kWhRequested | -0.109 | -0.028 | 0.023 | 0.044 | 0.691 | 1.000 | 0.945 | 0.420 | 0.106 | 0.081 |
| milesRequested | -0.398 | -0.029 | 0.035 | 0.071 | 0.698 | 0.945 | 1.000 | 0.414 | 0.088 | 0.086 |
| minutesAvailable | -0.125 | -0.015 | 0.000 | 0.005 | 0.389 | 0.420 | 0.414 | 1.000 | 0.009 | -0.009 |
| siteID | 0.063 | 0.166 | 0.232 | 0.226 | 0.208 | 0.106 | 0.088 | 0.009 | 1.000 | 0.182 |
| userID | -0.049 | -0.062 | 0.035 | 0.080 | 0.044 | 0.081 | 0.086 | -0.009 | 0.182 | 1.000 |
Missing values
Sample
| id | connectionTime | disconnectTime | doneChargingTime | kWhDelivered | sessionID | siteID | spaceID | stationID | timezone | userID | WhPerMile | kWhRequested | milesRequested | minutesAvailable | modifiedAt | paymentRequired | requestedDeparture | connectionTimespan | connectionMonth | connectionWeekdayName | isWeekend | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5e23b149f9af8b5fe4b973cf | 2020-01-02 05:08:54-08:00 | 2020-01-02 11:11:15-08:00 | 2020-01-02 09:31:35-08:00 | 25.016 | 1_1_179_810_2020-01-02 13:08:53.870034 | 1 | AG-3F30 | 1-1-179-810 | America/Los_Angeles | 194.0 | 250.0 | 25.00 | 100.0 | 463.0 | 2020-01-02 05:09:39-08:00 | True | 2020-01-02 12:51:54-08:00 | 0 days 06:02:21 | 1 | Thursday | False |
| 1 | 5e23b149f9af8b5fe4b973d0 | 2020-01-02 05:36:50-08:00 | 2020-01-02 14:38:21-08:00 | 2020-01-02 12:18:05-08:00 | 33.097 | 1_1_193_825_2020-01-02 13:36:49.599853 | 1 | AG-1F01 | 1-1-193-825 | America/Los_Angeles | 4275.0 | 280.0 | 70.00 | 250.0 | 595.0 | 2020-01-02 05:37:11-08:00 | True | 2020-01-02 15:31:50-08:00 | 0 days 09:01:31 | 1 | Thursday | False |
| 2 | 5e23b149f9af8b5fe4b973d1 | 2020-01-02 05:56:35-08:00 | 2020-01-02 16:39:22-08:00 | 2020-01-02 08:35:06-08:00 | 6.521 | 1_1_193_829_2020-01-02 13:56:35.214993 | 1 | AG-1F03 | 1-1-193-829 | America/Los_Angeles | 344.0 | 400.0 | 8.00 | 20.0 | 60.0 | 2020-01-02 05:57:17-08:00 | True | 2020-01-02 06:56:35-08:00 | 0 days 10:42:47 | 1 | Thursday | False |
| 3 | 5e23b149f9af8b5fe4b973d2 | 2020-01-02 05:59:58-08:00 | 2020-01-02 08:38:39-08:00 | 2020-01-02 07:18:45-08:00 | 2.355 | 1_1_193_820_2020-01-02 13:59:58.309319 | 1 | AG-1F04 | 1-1-193-820 | America/Los_Angeles | 1117.0 | 400.0 | 8.00 | 20.0 | 65.0 | 2020-01-02 06:00:03-08:00 | True | 2020-01-02 07:04:58-08:00 | 0 days 02:38:41 | 1 | Thursday | False |
| 4 | 5e23b149f9af8b5fe4b973d3 | 2020-01-02 06:00:01-08:00 | 2020-01-02 14:08:40-08:00 | 2020-01-02 10:17:30-08:00 | 13.375 | 1_1_193_819_2020-01-02 14:00:00.779967 | 1 | AG-1F06 | 1-1-193-819 | America/Los_Angeles | 334.0 | 400.0 | 16.00 | 40.0 | 504.0 | 2020-01-02 06:00:13-08:00 | True | 2020-01-02 14:24:01-08:00 | 0 days 08:08:39 | 1 | Thursday | False |
| 5 | 5e23b149f9af8b5fe4b973d4 | 2020-01-02 06:00:13-08:00 | 2020-01-02 15:00:41-08:00 | 2020-01-02 12:13:21-08:00 | 13.370 | 1_1_194_821_2020-01-02 14:00:05.241573 | 1 | AG-1F13 | 1-1-194-821 | America/Los_Angeles | 3519.0 | 600.0 | 24.00 | 40.0 | 624.0 | 2020-01-02 06:00:12-08:00 | True | 2020-01-02 16:24:13-08:00 | 0 days 09:00:28 | 1 | Thursday | False |
| 6 | 5e23b149f9af8b5fe4b973d5 | 2020-01-02 06:09:14-08:00 | 2020-01-02 17:57:58-08:00 | 2020-01-02 16:59:21-08:00 | 43.477 | 1_1_178_817_2020-01-02 14:09:14.451827 | 1 | AG-1F09 | 1-1-178-817 | America/Los_Angeles | 933.0 | 385.0 | 65.45 | 170.0 | 647.0 | 2020-01-02 06:09:33-08:00 | True | 2020-01-02 16:56:14-08:00 | 0 days 11:48:44 | 1 | Thursday | False |
| 7 | 5e23b149f9af8b5fe4b973d6 | 2020-01-02 06:17:32-08:00 | 2020-01-02 16:44:54-08:00 | 2020-01-02 12:22:40-08:00 | 32.441 | 1_1_191_804_2020-01-02 14:17:32.329535 | 1 | AG-4F34 | 1-1-191-804 | America/Los_Angeles | 3737.0 | 300.0 | 45.00 | 150.0 | 126.0 | 2020-01-02 06:17:40-08:00 | True | 2020-01-02 08:23:32-08:00 | 0 days 10:27:22 | 1 | Thursday | False |
| 8 | 5e23b149f9af8b5fe4b973d7 | 2020-01-02 06:25:38-08:00 | 2020-01-02 11:36:05-08:00 | 2020-01-02 10:38:39-08:00 | 13.264 | 1_1_194_826_2020-01-02 14:25:37.578692 | 1 | AG-1F11 | 1-1-194-826 | America/Los_Angeles | 419.0 | 400.0 | 40.00 | 100.0 | 491.0 | 2020-01-02 06:25:45-08:00 | True | 2020-01-02 14:36:38-08:00 | 0 days 05:10:27 | 1 | Thursday | False |
| 9 | 5e23b149f9af8b5fe4b973d8 | 2020-01-02 06:27:40-08:00 | 2020-01-02 12:01:48-08:00 | 2020-01-02 11:17:46-08:00 | 13.285 | 1_1_178_823_2020-01-02 14:27:39.582337 | 1 | AG-1F08 | 1-1-178-823 | America/Los_Angeles | 651.0 | 400.0 | 20.00 | 50.0 | 226.0 | 2020-01-02 06:27:48-08:00 | True | 2020-01-02 10:13:40-08:00 | 0 days 05:34:08 | 1 | Thursday | False |
| id | connectionTime | disconnectTime | doneChargingTime | kWhDelivered | sessionID | siteID | spaceID | stationID | timezone | userID | WhPerMile | kWhRequested | milesRequested | minutesAvailable | modifiedAt | paymentRequired | requestedDeparture | connectionTimespan | connectionMonth | connectionWeekdayName | isWeekend | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66440 | 5d574ad2f9af8b4c10c0364d | 2019-07-31 07:45:29-07:00 | 2019-07-31 15:01:32-07:00 | 2019-07-31 15:02:32-07:00 | 31.376 | 1_1_191_811_2019-07-31 14:45:29.388046 | 1 | AG-4F42 | 1-1-191-811 | America/Los_Angeles | 1626.0 | 200.0 | 38.00 | 190.0 | 209.0 | 2019-07-31 07:45:50-07:00 | True | 2019-07-31 11:14:29-07:00 | 0 days 07:16:03 | 7 | Wednesday | False |
| 66441 | 5d574ad2f9af8b4c10c0364e | 2019-07-31 07:46:58-07:00 | 2019-07-31 17:40:07-07:00 | 2019-07-31 10:22:58-07:00 | 5.051 | 1_1_191_782_2019-07-31 14:46:58.326897 | 1 | AG-4F50 | 1-1-191-782 | America/Los_Angeles | 2883.0 | 375.0 | 7.50 | 20.0 | 163.0 | 2019-07-31 07:47:05-07:00 | True | 2019-07-31 10:29:58-07:00 | 0 days 09:53:09 | 7 | Wednesday | False |
| 66442 | 5d574ad2f9af8b4c10c0364f | 2019-07-31 07:48:11-07:00 | 2019-07-31 18:33:50-07:00 | 2019-07-31 17:42:45-07:00 | 9.546 | 1_1_191_793_2019-07-31 14:48:10.568662 | 1 | AG-4F38 | 1-1-191-793 | America/Los_Angeles | 410.0 | 600.0 | 48.00 | 80.0 | 287.0 | 2019-07-31 07:48:33-07:00 | True | 2019-07-31 12:35:11-07:00 | 0 days 10:45:39 | 7 | Wednesday | False |
| 66443 | 5d574ad2f9af8b4c10c03650 | 2019-07-31 07:50:02-07:00 | 2019-07-31 16:19:49-07:00 | 2019-07-31 10:11:26-07:00 | 9.083 | 1_1_191_786_2019-07-31 14:50:01.704944 | 1 | AG-4F36 | 1-1-191-786 | America/Los_Angeles | 607.0 | 364.0 | 32.76 | 90.0 | 533.0 | 2019-07-31 07:50:13-07:00 | True | 2019-07-31 16:43:02-07:00 | 0 days 08:29:47 | 7 | Wednesday | False |
| 66444 | 5d574ad2f9af8b4c10c03651 | 2019-07-31 07:50:17-07:00 | 2019-07-31 18:01:18-07:00 | 2019-07-31 13:29:24-07:00 | 27.174 | 1_1_191_784_2019-07-31 14:50:17.037367 | 1 | AG-4F40 | 1-1-191-784 | America/Los_Angeles | 448.0 | 200.0 | 28.00 | 140.0 | 60.0 | 2019-07-31 07:53:40-07:00 | True | 2019-07-31 08:50:17-07:00 | 0 days 10:11:01 | 7 | Wednesday | False |
| 66445 | 5d574ad2f9af8b4c10c03652 | 2019-07-31 11:08:04-07:00 | 2019-07-31 16:29:18-07:00 | 2019-07-31 16:30:18-07:00 | 28.787 | 1_1_179_809_2019-07-31 18:08:04.432654 | 1 | AG-3F27 | 1-1-179-809 | America/Los_Angeles | 393.0 | 240.0 | 31.20 | 130.0 | 355.0 | 2019-07-31 11:08:23-07:00 | True | 2019-07-31 17:03:04-07:00 | 0 days 05:21:14 | 7 | Wednesday | False |
| 66446 | 5d574ad2f9af8b4c10c03653 | 2019-07-31 11:40:41-07:00 | 2019-07-31 17:59:42-07:00 | 2019-07-31 14:44:23-07:00 | 7.787 | 1_1_179_810_2019-07-31 18:40:40.900203 | 1 | AG-3F30 | 1-1-179-810 | America/Los_Angeles | 220.0 | 333.0 | 6.66 | 20.0 | 455.0 | 2019-07-31 11:41:02-07:00 | True | 2019-07-31 19:15:41-07:00 | 0 days 06:19:01 | 7 | Wednesday | False |
| 66447 | 5d574ad2f9af8b4c10c03654 | 2019-07-31 12:04:40-07:00 | 2019-07-31 15:44:22-07:00 | 2019-07-31 15:45:21-07:00 | 11.274 | 1_1_191_795_2019-07-31 19:04:40.098273 | 1 | AG-4F51 | 1-1-191-795 | America/Los_Angeles | 1974.0 | 333.0 | 19.98 | 60.0 | 184.0 | 2019-07-31 12:04:57-07:00 | True | 2019-07-31 15:08:40-07:00 | 0 days 03:39:42 | 7 | Wednesday | False |
| 66448 | 5d574ad2f9af8b4c10c03655 | 2019-07-31 12:19:47-07:00 | 2019-07-31 17:34:51-07:00 | 2019-07-31 14:25:30-07:00 | 11.589 | 1_1_191_778_2019-07-31 19:19:46.919358 | 1 | AG-4F43 | 1-1-191-778 | America/Los_Angeles | 942.0 | 275.0 | 22.00 | 80.0 | 60.0 | 2019-07-31 12:20:10-07:00 | True | 2019-07-31 13:19:47-07:00 | 0 days 05:15:04 | 7 | Wednesday | False |
| 66449 | 5d574ad2f9af8b4c10c03656 | 2019-07-31 12:21:47-07:00 | 2019-07-31 15:00:04-07:00 | 2019-07-31 13:51:34-07:00 | 0.897 | 1_1_178_817_2019-07-31 19:21:46.727697 | 1 | AG-1F09 | 1-1-178-817 | America/Los_Angeles | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaT | 0 days 02:38:17 | 7 | Wednesday | False |
Duplicate rows
Most frequently occurring
| id | connectionTime | disconnectTime | doneChargingTime | kWhDelivered | sessionID | siteID | spaceID | stationID | timezone | userID | WhPerMile | kWhRequested | milesRequested | minutesAvailable | modifiedAt | paymentRequired | requestedDeparture | connectionMonth | connectionWeekdayName | isWeekend | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5d2fbdd3f9af8b4d0dd0d54f | 2019-07-01 17:32:46-07:00 | 2019-07-01 19:34:56-07:00 | 2019-07-01 18:46:09-07:00 | 2.463 | 1_1_193_827_2019-07-02 00:32:45.820079 | 1 | AG-1F02 | 1-1-193-827 | America/Los_Angeles | 1117.0 | 200.0 | 4.00 | 20.0 | 90.0 | 2019-07-01 17:32:53-07:00 | True | 2019-07-01 19:02:46-07:00 | 7 | Monday | False | 2 |
| 1 | 5d310f54f9af8b52adda3e20 | 2019-07-02 05:15:28-07:00 | 2019-07-02 09:01:01-07:00 | 2019-07-02 09:01:38-07:00 | 12.891 | 1_1_194_818_2019-07-02 12:15:28.503952 | 1 | AG-1F14 | 1-1-194-818 | America/Los_Angeles | 2834.0 | 273.0 | 19.11 | 70.0 | 332.0 | 2019-07-02 05:18:12-07:00 | True | 2019-07-02 10:47:28-07:00 | 7 | Tuesday | False | 2 |
| 2 | 5d310f54f9af8b52adda3e21 | 2019-07-02 05:42:49-07:00 | 2019-07-02 12:34:19-07:00 | 2019-07-02 09:21:21-07:00 | 13.734 | 1_1_178_828_2019-07-02 12:42:48.733464 | 1 | AG-1F10 | 1-1-178-828 | America/Los_Angeles | 651.0 | 400.0 | 20.00 | 50.0 | 186.0 | 2019-07-02 05:43:19-07:00 | True | 2019-07-02 08:48:49-07:00 | 7 | Tuesday | False | 2 |
| 3 | 5d310f54f9af8b52adda3e22 | 2019-07-02 05:44:46-07:00 | 2019-07-02 15:33:29-07:00 | 2019-07-02 09:28:09-07:00 | 10.619 | 1_1_178_823_2019-07-02 12:44:45.734064 | 1 | AG-1F08 | 1-1-178-823 | America/Los_Angeles | 406.0 | 600.0 | 24.00 | 40.0 | 581.0 | 2019-07-02 05:45:09-07:00 | True | 2019-07-02 15:25:46-07:00 | 7 | Tuesday | False | 2 |
| 4 | 5d310f54f9af8b52adda3e23 | 2019-07-02 05:52:53-07:00 | 2019-07-02 12:21:25-07:00 | 2019-07-02 10:55:13-07:00 | 19.079 | 1_1_179_799_2019-07-02 12:52:52.691064 | 1 | AG-3F25 | 1-1-179-799 | America/Los_Angeles | 439.0 | 300.0 | 78.00 | 260.0 | 534.0 | 2019-07-02 05:53:40-07:00 | True | 2019-07-02 14:46:53-07:00 | 7 | Tuesday | False | 2 |
| 5 | 5d310f54f9af8b52adda3e24 | 2019-07-02 06:02:13-07:00 | 2019-07-02 12:04:02-07:00 | 2019-07-02 07:14:25-07:00 | 2.414 | 1_1_193_827_2019-07-02 13:02:12.544018 | 1 | AG-1F02 | 1-1-193-827 | America/Los_Angeles | 1117.0 | 200.0 | 4.00 | 20.0 | 90.0 | 2019-07-02 06:02:13-07:00 | True | 2019-07-02 07:32:13-07:00 | 7 | Tuesday | False | 2 |
| 6 | 5d310f54f9af8b52adda3e25 | 2019-07-02 06:05:00-07:00 | 2019-07-02 15:13:28-07:00 | 2019-07-02 10:33:35-07:00 | 12.130 | 1_1_193_819_2019-07-02 13:05:00.715639 | 1 | AG-1F06 | 1-1-193-819 | America/Los_Angeles | 334.0 | 575.0 | 28.75 | 50.0 | 455.0 | 2019-07-02 06:05:09-07:00 | True | 2019-07-02 13:40:00-07:00 | 7 | Tuesday | False | 2 |
| 7 | 5d310f54f9af8b52adda3e26 | 2019-07-02 06:14:59-07:00 | 2019-07-02 16:07:57-07:00 | 2019-07-02 09:31:16-07:00 | 7.316 | 1_1_193_820_2019-07-02 13:14:59.483416 | 1 | AG-1F04 | 1-1-193-820 | America/Los_Angeles | 1627.0 | 400.0 | 8.00 | 20.0 | 646.0 | 2019-07-02 06:15:13-07:00 | True | 2019-07-02 17:00:59-07:00 | 7 | Tuesday | False | 2 |
| 8 | 5d310f54f9af8b52adda3e27 | 2019-07-02 06:18:28-07:00 | 2019-07-02 16:16:24-07:00 | 2019-07-02 15:45:11-07:00 | 18.368 | 1_1_179_788_2019-07-02 13:18:27.824619 | 1 | AG-3F22 | 1-1-179-788 | America/Los_Angeles | 529.0 | 300.0 | 18.00 | 60.0 | 541.0 | 2019-07-02 06:18:44-07:00 | True | 2019-07-02 15:19:28-07:00 | 7 | Tuesday | False | 2 |
| 9 | 5d310f54f9af8b52adda3e28 | 2019-07-02 06:25:01-07:00 | 2019-07-02 15:39:18-07:00 | 2019-07-02 09:29:23-07:00 | 13.924 | 1_1_178_817_2019-07-02 13:25:01.464654 | 1 | AG-1F09 | 1-1-178-817 | America/Los_Angeles | 322.0 | 313.0 | 18.78 | 60.0 | 418.0 | 2019-07-02 06:25:07-07:00 | True | 2019-07-02 13:23:01-07:00 | 7 | Tuesday | False | 2 |